package com.atguigu.edu.mapper;

import com.atguigu.edu.bean.PaperClassStats;
import com.atguigu.edu.bean.PaperExamStats;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface PaperClassStatsMapper {

    @Select("select course_name,sum(test_exam_people) testExamPeople" +
            " ,avg(test_avg_score) testAvgScore ,avg(test_avg_time) testAvgTime \n" +
            "from dws_exam_class_exam_statistics_window partition par#{date} group by course_name")
    List<PaperClassStats> selectPaperClass(Integer date );
}
